Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | RetailStore(PA_STR_RTL) |
ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
ItemID (FK)(PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | RelatedItemAssociation(CO_ASCTN_RLTD_ITM) |
RelatedItemID (FK)(PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM_RLTD | IdentityUUID | char(32) | RelatedItemAssociation(CO_ASCTN_RLTD_ITM) |
RelatedItemAssociationTypeCode (FK)(PK) | A retailer assigned code defining a type of association between two items that are generally sold together. | CD_TYP_RLTD_ITM | Code2 | char(2) | RelatedItemAssociation(CO_ASCTN_RLTD_ITM) |
SoldTogetherTransactionCount | A count of the number of transactions in which the items in the item association were sold together. | QU_TRN_ASCTN_SD_TG | QuantityTransactionCount | decimal(7,0) | |
SoldSeparatelyTransactionCount | Count of transactions in which the item is sold without the associated item. | QU_ITM_SD_SPRTLY | QuantityTransactionCount | decimal(7,0) | |
RelatedItemSoldSeparatelyTransactionCount | Count of transactions in which the associated item is sold without the item. | QU_TRN_SLD_SPRTLY | QuantityTransactionCount | decimal(7,0) | |
TotalSalesTransactionCount | Total sale transaction count for the same period as the item association accumulators - used to calculate ratios and percentages. | QU_TRN_SLS_TOT | QuantityTransactionCount | decimal(7,0) | |